﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="SouthridgeDataSet" targetNamespace="http://tempuri.org/SouthridgeDataSet.xsd" xmlns:mstns="http://tempuri.org/SouthridgeDataSet.xsd" xmlns="http://tempuri.org/SouthridgeDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="SouthridgeConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="SouthridgeConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.Southridge.Properties.Settings.GlobalReference.Default.SouthridgeConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ListingsTableAdapter" GeneratorDataComponentClassName="ListingsTableAdapter" Name="Listings" UserDataComponentName="ListingsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SouthridgeConnectionString (Settings)" DbObjectName="Southridge.dbo.Listings" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Listings] WHERE (([MLS] = @Original_MLS) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Price = 1 AND [Price] IS NULL) OR ([Price] = @Original_Price)) AND ((@IsNull_Street = 1 AND [Street] IS NULL) OR ([Street] = @Original_Street)) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City)) AND ((@IsNull_State = 1 AND [State] IS NULL) OR ([State] = @Original_State)) AND ((@IsNull_ZIP = 1 AND [ZIP] IS NULL) OR ([ZIP] = @Original_ZIP)) AND ((@IsNull_BedroomCount = 1 AND [BedroomCount] IS NULL) OR ([BedroomCount] = @Original_BedroomCount)) AND ((@IsNull_BathroomCount = 1 AND [BathroomCount] IS NULL) OR ([BathroomCount] = @Original_BathroomCount)) AND ((@IsNull_Year = 1 AND [Year] IS NULL) OR ([Year] = @Original_Year)) AND ((@IsNull_SquareFootage = 1 AND [SquareFootage] IS NULL) OR ([SquareFootage] = @Original_SquareFootage)) AND ((@IsNull_ApptDate = 1 AND [ApptDate] IS NULL) OR ([ApptDate] = @Original_ApptDate)) AND ((@IsNull_NeighborhoodID = 1 AND [NeighborhoodID] IS NULL) OR ([NeighborhoodID] = @Original_NeighborhoodID)) AND ((@IsNull_PrimaryPhoto = 1 AND [PrimaryPhoto] IS NULL) OR ([PrimaryPhoto] = @Original_PrimaryPhoto)) AND ((@IsNull_DatePosted = 1 AND [DatePosted] IS NULL) OR ([DatePosted] = @Original_DatePosted)) AND ((@IsNull_DateLastUpdated = 1 AND [DateLastUpdated] IS NULL) OR ([DateLastUpdated] = @Original_DateLastUpdated)) AND ((@IsNull_ClientRating = 1 AND [ClientRating] IS NULL) OR ([ClientRating] = @Original_ClientRating)) AND ((@IsNull_HasPhotos = 1 AND [HasPhotos] IS NULL) OR ([HasPhotos] = @Original_HasPhotos)) AND ((@IsNull_HasAppt = 1 AND [HasAppt] IS NULL) OR ([HasAppt] = @Original_HasAppt)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MLS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MLS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Street" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Street" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_City" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_State" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ZIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZIP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ZIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZIP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BedroomCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BedroomCount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BedroomCount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BedroomCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BathroomCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BathroomCount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BathroomCount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BathroomCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Year" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Year" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SquareFootage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SquareFootage" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SquareFootage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SquareFootage" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApptDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApptDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ApptDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApptDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NeighborhoodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NeighborhoodID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NeighborhoodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NeighborhoodID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrimaryPhoto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrimaryPhoto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PrimaryPhoto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PrimaryPhoto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DatePosted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DatePosted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DatePosted" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DatePosted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateLastUpdated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateLastUpdated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateLastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateLastUpdated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientRating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientRating" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClientRating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientRating" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HasPhotos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HasPhotos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_HasPhotos" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasPhotos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HasAppt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HasAppt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_HasAppt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasAppt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Listings] ([MLS], [Title], [Price], [Street], [City], [State], [ZIP], [BedroomCount], [BathroomCount], [Year], [SquareFootage], [Description], [ApptDate], [NeighborhoodID], [PrimaryPhoto], [DatePosted], [DateLastUpdated], [ClientRating], [HasPhotos], [HasAppt]) VALUES (@MLS, @Title, @Price, @Street, @City, @State, @ZIP, @BedroomCount, @BathroomCount, @Year, @SquareFootage, @Description, @ApptDate, @NeighborhoodID, @PrimaryPhoto, @DatePosted, @DateLastUpdated, @ClientRating, @HasPhotos, @HasAppt);
SELECT MLS, Title, Price, Street, City, State, ZIP, BedroomCount, BathroomCount, Year, SquareFootage, Description, ApptDate, NeighborhoodID, PrimaryPhoto, DatePosted, DateLastUpdated, ClientRating, HasPhotos, HasAppt FROM Listings WHERE (MLS = @MLS)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MLS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MLS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Street" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ZIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BedroomCount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BedroomCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BathroomCount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BathroomCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Year" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SquareFootage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SquareFootage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ApptDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApptDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NeighborhoodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NeighborhoodID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PrimaryPhoto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PrimaryPhoto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DatePosted" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DatePosted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateLastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateLastUpdated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ClientRating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientRating" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@HasPhotos" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasPhotos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@HasAppt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasAppt" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT MLS, Title, Price, Street, City, State, ZIP, BedroomCount, BathroomCount, Year, SquareFootage, Description, ApptDate, NeighborhoodID, PrimaryPhoto, DatePosted, DateLastUpdated, ClientRating, HasPhotos, HasAppt FROM dbo.Listings</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Listings] SET [MLS] = @MLS, [Title] = @Title, [Price] = @Price, [Street] = @Street, [City] = @City, [State] = @State, [ZIP] = @ZIP, [BedroomCount] = @BedroomCount, [BathroomCount] = @BathroomCount, [Year] = @Year, [SquareFootage] = @SquareFootage, [Description] = @Description, [ApptDate] = @ApptDate, [NeighborhoodID] = @NeighborhoodID, [PrimaryPhoto] = @PrimaryPhoto, [DatePosted] = @DatePosted, [DateLastUpdated] = @DateLastUpdated, [ClientRating] = @ClientRating, [HasPhotos] = @HasPhotos, [HasAppt] = @HasAppt WHERE (([MLS] = @Original_MLS) AND ((@IsNull_Title = 1 AND [Title] IS NULL) OR ([Title] = @Original_Title)) AND ((@IsNull_Price = 1 AND [Price] IS NULL) OR ([Price] = @Original_Price)) AND ((@IsNull_Street = 1 AND [Street] IS NULL) OR ([Street] = @Original_Street)) AND ((@IsNull_City = 1 AND [City] IS NULL) OR ([City] = @Original_City)) AND ((@IsNull_State = 1 AND [State] IS NULL) OR ([State] = @Original_State)) AND ((@IsNull_ZIP = 1 AND [ZIP] IS NULL) OR ([ZIP] = @Original_ZIP)) AND ((@IsNull_BedroomCount = 1 AND [BedroomCount] IS NULL) OR ([BedroomCount] = @Original_BedroomCount)) AND ((@IsNull_BathroomCount = 1 AND [BathroomCount] IS NULL) OR ([BathroomCount] = @Original_BathroomCount)) AND ((@IsNull_Year = 1 AND [Year] IS NULL) OR ([Year] = @Original_Year)) AND ((@IsNull_SquareFootage = 1 AND [SquareFootage] IS NULL) OR ([SquareFootage] = @Original_SquareFootage)) AND ((@IsNull_ApptDate = 1 AND [ApptDate] IS NULL) OR ([ApptDate] = @Original_ApptDate)) AND ((@IsNull_NeighborhoodID = 1 AND [NeighborhoodID] IS NULL) OR ([NeighborhoodID] = @Original_NeighborhoodID)) AND ((@IsNull_PrimaryPhoto = 1 AND [PrimaryPhoto] IS NULL) OR ([PrimaryPhoto] = @Original_PrimaryPhoto)) AND ((@IsNull_DatePosted = 1 AND [DatePosted] IS NULL) OR ([DatePosted] = @Original_DatePosted)) AND ((@IsNull_DateLastUpdated = 1 AND [DateLastUpdated] IS NULL) OR ([DateLastUpdated] = @Original_DateLastUpdated)) AND ((@IsNull_ClientRating = 1 AND [ClientRating] IS NULL) OR ([ClientRating] = @Original_ClientRating)) AND ((@IsNull_HasPhotos = 1 AND [HasPhotos] IS NULL) OR ([HasPhotos] = @Original_HasPhotos)) AND ((@IsNull_HasAppt = 1 AND [HasAppt] IS NULL) OR ([HasAppt] = @Original_HasAppt)));
SELECT MLS, Title, Price, Street, City, State, ZIP, BedroomCount, BathroomCount, Year, SquareFootage, Description, ApptDate, NeighborhoodID, PrimaryPhoto, DatePosted, DateLastUpdated, ClientRating, HasPhotos, HasAppt FROM Listings WHERE (MLS = @MLS)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MLS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MLS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Street" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ZIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BedroomCount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BedroomCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@BathroomCount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BathroomCount" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Year" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SquareFootage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SquareFootage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="Text" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ApptDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApptDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NeighborhoodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NeighborhoodID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PrimaryPhoto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PrimaryPhoto" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DatePosted" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DatePosted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateLastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateLastUpdated" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ClientRating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientRating" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@HasPhotos" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasPhotos" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@HasAppt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasAppt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MLS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MLS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Title" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Price" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Price" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Street" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Street" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Street" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_City" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_City" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="City" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_State" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_State" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="State" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ZIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZIP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ZIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ZIP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BedroomCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BedroomCount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BedroomCount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BedroomCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BathroomCount" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BathroomCount" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_BathroomCount" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="BathroomCount" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Year" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Year" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Year" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SquareFootage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SquareFootage" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SquareFootage" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SquareFootage" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApptDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApptDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ApptDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApptDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NeighborhoodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NeighborhoodID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NeighborhoodID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NeighborhoodID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrimaryPhoto" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrimaryPhoto" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PrimaryPhoto" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PrimaryPhoto" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DatePosted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DatePosted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DatePosted" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DatePosted" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateLastUpdated" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateLastUpdated" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateLastUpdated" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateLastUpdated" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClientRating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientRating" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClientRating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClientRating" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HasPhotos" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HasPhotos" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_HasPhotos" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasPhotos" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HasAppt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HasAppt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_HasAppt" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="HasAppt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="MLS" DataSetColumn="MLS" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="Price" DataSetColumn="Price" />
              <Mapping SourceColumn="Street" DataSetColumn="Street" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="State" DataSetColumn="State" />
              <Mapping SourceColumn="ZIP" DataSetColumn="ZIP" />
              <Mapping SourceColumn="BedroomCount" DataSetColumn="BedroomCount" />
              <Mapping SourceColumn="BathroomCount" DataSetColumn="BathroomCount" />
              <Mapping SourceColumn="Year" DataSetColumn="Year" />
              <Mapping SourceColumn="SquareFootage" DataSetColumn="SquareFootage" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="ApptDate" DataSetColumn="ApptDate" />
              <Mapping SourceColumn="NeighborhoodID" DataSetColumn="NeighborhoodID" />
              <Mapping SourceColumn="PrimaryPhoto" DataSetColumn="PrimaryPhoto" />
              <Mapping SourceColumn="DatePosted" DataSetColumn="DatePosted" />
              <Mapping SourceColumn="DateLastUpdated" DataSetColumn="DateLastUpdated" />
              <Mapping SourceColumn="ClientRating" DataSetColumn="ClientRating" />
              <Mapping SourceColumn="HasPhotos" DataSetColumn="HasPhotos" />
              <Mapping SourceColumn="HasAppt" DataSetColumn="HasAppt" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="NeighborhoodsTableAdapter" GeneratorDataComponentClassName="NeighborhoodsTableAdapter" Name="Neighborhoods" UserDataComponentName="NeighborhoodsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SouthridgeConnectionString (Settings)" DbObjectName="Southridge.dbo.Neighborhoods" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Neighborhoods] WHERE (([ID] = @Original_ID) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ([IsHighGrowth] = @Original_IsHighGrowth) AND ([IsNearCenterCity] = @Original_IsNearCenterCity) AND ([IsNearCommunityCenter] = @Original_IsNearCommunityCenter) AND ([IsNearDining] = @Original_IsNearDining) AND ([IsNearFamilyActivities] = @Original_IsNearFamilyActivities) AND ([IsNearParks] = @Original_IsNearParks) AND ([IsNearShopping] = @Original_IsNearShopping))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsHighGrowth" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsHighGrowth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsNearCenterCity" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearCenterCity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsNearCommunityCenter" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearCommunityCenter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsNearDining" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearDining" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsNearFamilyActivities" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearFamilyActivities" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsNearParks" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearParks" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsNearShopping" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearShopping" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Neighborhoods] ([ID], [Name], [IsHighGrowth], [IsNearCenterCity], [IsNearCommunityCenter], [IsNearDining], [IsNearFamilyActivities], [IsNearParks], [IsNearShopping]) VALUES (@ID, @Name, @IsHighGrowth, @IsNearCenterCity, @IsNearCommunityCenter, @IsNearDining, @IsNearFamilyActivities, @IsNearParks, @IsNearShopping);
SELECT ID, Name, IsHighGrowth, IsNearCenterCity, IsNearCommunityCenter, IsNearDining, IsNearFamilyActivities, IsNearParks, IsNearShopping FROM Neighborhoods WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsHighGrowth" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsHighGrowth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsNearCenterCity" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearCenterCity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsNearCommunityCenter" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearCommunityCenter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsNearDining" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearDining" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsNearFamilyActivities" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearFamilyActivities" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsNearParks" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearParks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsNearShopping" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearShopping" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, Name, IsHighGrowth, IsNearCenterCity, IsNearCommunityCenter, IsNearDining, IsNearFamilyActivities, IsNearParks, IsNearShopping FROM dbo.Neighborhoods</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Neighborhoods] SET [ID] = @ID, [Name] = @Name, [IsHighGrowth] = @IsHighGrowth, [IsNearCenterCity] = @IsNearCenterCity, [IsNearCommunityCenter] = @IsNearCommunityCenter, [IsNearDining] = @IsNearDining, [IsNearFamilyActivities] = @IsNearFamilyActivities, [IsNearParks] = @IsNearParks, [IsNearShopping] = @IsNearShopping WHERE (([ID] = @Original_ID) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ([IsHighGrowth] = @Original_IsHighGrowth) AND ([IsNearCenterCity] = @Original_IsNearCenterCity) AND ([IsNearCommunityCenter] = @Original_IsNearCommunityCenter) AND ([IsNearDining] = @Original_IsNearDining) AND ([IsNearFamilyActivities] = @Original_IsNearFamilyActivities) AND ([IsNearParks] = @Original_IsNearParks) AND ([IsNearShopping] = @Original_IsNearShopping));
SELECT ID, Name, IsHighGrowth, IsNearCenterCity, IsNearCommunityCenter, IsNearDining, IsNearFamilyActivities, IsNearParks, IsNearShopping FROM Neighborhoods WHERE (ID = @ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsHighGrowth" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsHighGrowth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsNearCenterCity" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearCenterCity" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsNearCommunityCenter" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearCommunityCenter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsNearDining" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearDining" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsNearFamilyActivities" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearFamilyActivities" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsNearParks" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearParks" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsNearShopping" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearShopping" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsHighGrowth" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsHighGrowth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsNearCenterCity" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearCenterCity" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsNearCommunityCenter" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearCommunityCenter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsNearDining" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearDining" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsNearFamilyActivities" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearFamilyActivities" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsNearParks" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearParks" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsNearShopping" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsNearShopping" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="IsHighGrowth" DataSetColumn="IsHighGrowth" />
              <Mapping SourceColumn="IsNearCenterCity" DataSetColumn="IsNearCenterCity" />
              <Mapping SourceColumn="IsNearCommunityCenter" DataSetColumn="IsNearCommunityCenter" />
              <Mapping SourceColumn="IsNearDining" DataSetColumn="IsNearDining" />
              <Mapping SourceColumn="IsNearFamilyActivities" DataSetColumn="IsNearFamilyActivities" />
              <Mapping SourceColumn="IsNearParks" DataSetColumn="IsNearParks" />
              <Mapping SourceColumn="IsNearShopping" DataSetColumn="IsNearShopping" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ViewingsTableAdapter" GeneratorDataComponentClassName="ViewingsTableAdapter" Name="Viewings" UserDataComponentName="ViewingsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="SouthridgeConnectionString (Settings)" DbObjectName="Southridge.dbo.Viewings" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Viewings] WHERE (([ViewingID] = @Original_ViewingID) AND ([MLS] = @Original_MLS) AND ((@IsNull_BuyerName = 1 AND [BuyerName] IS NULL) OR ([BuyerName] = @Original_BuyerName)) AND ((@IsNull_BuyerPhone = 1 AND [BuyerPhone] IS NULL) OR ([BuyerPhone] = @Original_BuyerPhone)) AND ([ViewingDate] = @Original_ViewingDate) AND ([WasInterested] = @Original_WasInterested) AND ([Proceeding] = @Original_Proceeding) AND ((@IsNull_BuyerIsMortgageApproved = 1 AND [BuyerIsMortgageApproved] IS NULL) OR ([BuyerIsMortgageApproved] = @Original_BuyerIsMortgageApproved)) AND ((@IsNull_BuyerMortgageLimit = 1 AND [BuyerMortgageLimit] IS NULL) OR ([BuyerMortgageLimit] = @Original_BuyerMortgageLimit)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ViewingID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ViewingID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MLS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MLS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuyerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuyerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BuyerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BuyerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuyerPhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuyerPhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BuyerPhone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BuyerPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ViewingDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ViewingDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_WasInterested" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="WasInterested" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Proceeding" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Proceeding" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuyerIsMortgageApproved" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuyerIsMortgageApproved" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_BuyerIsMortgageApproved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BuyerIsMortgageApproved" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuyerMortgageLimit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuyerMortgageLimit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BuyerMortgageLimit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuyerMortgageLimit" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Viewings] ([ViewingID], [MLS], [BuyerName], [BuyerPhone], [ViewingDate], [WasInterested], [Proceeding], [BuyerIsMortgageApproved], [BuyerMortgageLimit]) VALUES (@ViewingID, @MLS, @BuyerName, @BuyerPhone, @ViewingDate, @WasInterested, @Proceeding, @BuyerIsMortgageApproved, @BuyerMortgageLimit);
SELECT ViewingID, MLS, BuyerName, BuyerPhone, ViewingDate, WasInterested, Proceeding, BuyerIsMortgageApproved, BuyerMortgageLimit FROM Viewings WHERE (ViewingID = @ViewingID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ViewingID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ViewingID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MLS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MLS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BuyerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BuyerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BuyerPhone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BuyerPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ViewingDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ViewingDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@WasInterested" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="WasInterested" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Proceeding" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Proceeding" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@BuyerIsMortgageApproved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BuyerIsMortgageApproved" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BuyerMortgageLimit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuyerMortgageLimit" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ViewingID, MLS, BuyerName, BuyerPhone, ViewingDate, WasInterested, Proceeding, BuyerIsMortgageApproved, BuyerMortgageLimit FROM dbo.Viewings</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Viewings] SET [ViewingID] = @ViewingID, [MLS] = @MLS, [BuyerName] = @BuyerName, [BuyerPhone] = @BuyerPhone, [ViewingDate] = @ViewingDate, [WasInterested] = @WasInterested, [Proceeding] = @Proceeding, [BuyerIsMortgageApproved] = @BuyerIsMortgageApproved, [BuyerMortgageLimit] = @BuyerMortgageLimit WHERE (([ViewingID] = @Original_ViewingID) AND ([MLS] = @Original_MLS) AND ((@IsNull_BuyerName = 1 AND [BuyerName] IS NULL) OR ([BuyerName] = @Original_BuyerName)) AND ((@IsNull_BuyerPhone = 1 AND [BuyerPhone] IS NULL) OR ([BuyerPhone] = @Original_BuyerPhone)) AND ([ViewingDate] = @Original_ViewingDate) AND ([WasInterested] = @Original_WasInterested) AND ([Proceeding] = @Original_Proceeding) AND ((@IsNull_BuyerIsMortgageApproved = 1 AND [BuyerIsMortgageApproved] IS NULL) OR ([BuyerIsMortgageApproved] = @Original_BuyerIsMortgageApproved)) AND ((@IsNull_BuyerMortgageLimit = 1 AND [BuyerMortgageLimit] IS NULL) OR ([BuyerMortgageLimit] = @Original_BuyerMortgageLimit)));
SELECT ViewingID, MLS, BuyerName, BuyerPhone, ViewingDate, WasInterested, Proceeding, BuyerIsMortgageApproved, BuyerMortgageLimit FROM Viewings WHERE (ViewingID = @ViewingID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ViewingID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ViewingID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MLS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MLS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BuyerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BuyerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@BuyerPhone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BuyerPhone" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ViewingDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ViewingDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@WasInterested" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="WasInterested" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Proceeding" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Proceeding" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@BuyerIsMortgageApproved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BuyerIsMortgageApproved" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BuyerMortgageLimit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuyerMortgageLimit" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ViewingID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ViewingID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MLS" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MLS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuyerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuyerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BuyerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BuyerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuyerPhone" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuyerPhone" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_BuyerPhone" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="BuyerPhone" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ViewingDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ViewingDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_WasInterested" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="WasInterested" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Proceeding" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Proceeding" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuyerIsMortgageApproved" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuyerIsMortgageApproved" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_BuyerIsMortgageApproved" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="BuyerIsMortgageApproved" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuyerMortgageLimit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuyerMortgageLimit" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BuyerMortgageLimit" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuyerMortgageLimit" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ViewingID" DataSetColumn="ViewingID" />
              <Mapping SourceColumn="MLS" DataSetColumn="MLS" />
              <Mapping SourceColumn="BuyerName" DataSetColumn="BuyerName" />
              <Mapping SourceColumn="BuyerPhone" DataSetColumn="BuyerPhone" />
              <Mapping SourceColumn="ViewingDate" DataSetColumn="ViewingDate" />
              <Mapping SourceColumn="WasInterested" DataSetColumn="WasInterested" />
              <Mapping SourceColumn="Proceeding" DataSetColumn="Proceeding" />
              <Mapping SourceColumn="BuyerIsMortgageApproved" DataSetColumn="BuyerIsMortgageApproved" />
              <Mapping SourceColumn="BuyerMortgageLimit" DataSetColumn="BuyerMortgageLimit" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="SouthridgeDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="SouthridgeDataSet" msprop:Generator_UserDSName="SouthridgeDataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Listings" msprop:Generator_UserTableName="Listings" msprop:Generator_RowDeletedName="ListingsRowDeleted" msprop:Generator_TableClassName="ListingsDataTable" msprop:Generator_RowChangedName="ListingsRowChanged" msprop:Generator_RowDeletingName="ListingsRowDeleting" msprop:Generator_RowChangingName="ListingsRowChanging" msprop:Generator_RowEvArgName="ListingsRowChangeEvent" msprop:Generator_RowClassName="ListingsRow" msprop:Generator_RowEvHandlerName="ListingsRowChangeEventHandler" msprop:Generator_TablePropName="Listings" msprop:Generator_TableVarName="tableListings">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="MLS" msprop:Generator_UserColumnName="MLS" msprop:Generator_ColumnPropNameInRow="MLS" msprop:Generator_ColumnVarNameInTable="columnMLS" msprop:Generator_ColumnPropNameInTable="MLSColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInTable="TitleColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Price" msprop:Generator_UserColumnName="Price" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInTable="PriceColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Street" msprop:Generator_UserColumnName="Street" msprop:Generator_ColumnPropNameInRow="Street" msprop:Generator_ColumnVarNameInTable="columnStreet" msprop:Generator_ColumnPropNameInTable="StreetColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_UserColumnName="City" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInTable="CityColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="State" msprop:Generator_UserColumnName="State" msprop:Generator_ColumnPropNameInRow="State" msprop:Generator_ColumnVarNameInTable="columnState" msprop:Generator_ColumnPropNameInTable="StateColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ZIP" msprop:Generator_UserColumnName="ZIP" msprop:Generator_ColumnPropNameInRow="ZIP" msprop:Generator_ColumnVarNameInTable="columnZIP" msprop:Generator_ColumnPropNameInTable="ZIPColumn" type="xs:int" minOccurs="0" />
              <xs:element name="BedroomCount" msprop:Generator_UserColumnName="BedroomCount" msprop:Generator_ColumnPropNameInRow="BedroomCount" msprop:Generator_ColumnVarNameInTable="columnBedroomCount" msprop:Generator_ColumnPropNameInTable="BedroomCountColumn" type="xs:double" minOccurs="0" />
              <xs:element name="BathroomCount" msprop:Generator_UserColumnName="BathroomCount" msprop:Generator_ColumnPropNameInRow="BathroomCount" msprop:Generator_ColumnVarNameInTable="columnBathroomCount" msprop:Generator_ColumnPropNameInTable="BathroomCountColumn" type="xs:double" minOccurs="0" />
              <xs:element name="Year" msprop:Generator_UserColumnName="Year" msprop:Generator_ColumnPropNameInRow="Year" msprop:Generator_ColumnVarNameInTable="columnYear" msprop:Generator_ColumnPropNameInTable="YearColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SquareFootage" msprop:Generator_UserColumnName="SquareFootage" msprop:Generator_ColumnPropNameInRow="SquareFootage" msprop:Generator_ColumnVarNameInTable="columnSquareFootage" msprop:Generator_ColumnPropNameInTable="SquareFootageColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ApptDate" msprop:Generator_UserColumnName="ApptDate" msprop:Generator_ColumnPropNameInRow="ApptDate" msprop:Generator_ColumnVarNameInTable="columnApptDate" msprop:Generator_ColumnPropNameInTable="ApptDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NeighborhoodID" msprop:Generator_UserColumnName="NeighborhoodID" msprop:Generator_ColumnPropNameInRow="NeighborhoodID" msprop:Generator_ColumnVarNameInTable="columnNeighborhoodID" msprop:Generator_ColumnPropNameInTable="NeighborhoodIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="PrimaryPhoto" msprop:Generator_UserColumnName="PrimaryPhoto" msprop:Generator_ColumnPropNameInRow="PrimaryPhoto" msprop:Generator_ColumnVarNameInTable="columnPrimaryPhoto" msprop:Generator_ColumnPropNameInTable="PrimaryPhotoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DatePosted" msprop:Generator_UserColumnName="DatePosted" msprop:Generator_ColumnPropNameInRow="DatePosted" msprop:Generator_ColumnVarNameInTable="columnDatePosted" msprop:Generator_ColumnPropNameInTable="DatePostedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DateLastUpdated" msprop:Generator_UserColumnName="DateLastUpdated" msprop:Generator_ColumnPropNameInRow="DateLastUpdated" msprop:Generator_ColumnVarNameInTable="columnDateLastUpdated" msprop:Generator_ColumnPropNameInTable="DateLastUpdatedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ClientRating" msprop:Generator_UserColumnName="ClientRating" msprop:Generator_ColumnPropNameInRow="ClientRating" msprop:Generator_ColumnVarNameInTable="columnClientRating" msprop:Generator_ColumnPropNameInTable="ClientRatingColumn" type="xs:int" minOccurs="0" />
              <xs:element name="HasPhotos" msprop:Generator_UserColumnName="HasPhotos" msprop:Generator_ColumnPropNameInRow="HasPhotos" msprop:Generator_ColumnVarNameInTable="columnHasPhotos" msprop:Generator_ColumnPropNameInTable="HasPhotosColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="HasAppt" msprop:Generator_UserColumnName="HasAppt" msprop:Generator_ColumnPropNameInRow="HasAppt" msprop:Generator_ColumnVarNameInTable="columnHasAppt" msprop:Generator_ColumnPropNameInTable="HasApptColumn" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Neighborhoods" msprop:Generator_UserTableName="Neighborhoods" msprop:Generator_RowDeletedName="NeighborhoodsRowDeleted" msprop:Generator_TableClassName="NeighborhoodsDataTable" msprop:Generator_RowChangedName="NeighborhoodsRowChanged" msprop:Generator_RowDeletingName="NeighborhoodsRowDeleting" msprop:Generator_RowChangingName="NeighborhoodsRowChanging" msprop:Generator_RowEvArgName="NeighborhoodsRowChangeEvent" msprop:Generator_RowClassName="NeighborhoodsRow" msprop:Generator_RowEvHandlerName="NeighborhoodsRowChangeEventHandler" msprop:Generator_TablePropName="Neighborhoods" msprop:Generator_TableVarName="tableNeighborhoods">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsHighGrowth" msprop:Generator_UserColumnName="IsHighGrowth" msprop:Generator_ColumnPropNameInRow="IsHighGrowth" msprop:Generator_ColumnVarNameInTable="columnIsHighGrowth" msprop:Generator_ColumnPropNameInTable="IsHighGrowthColumn" type="xs:boolean" />
              <xs:element name="IsNearCenterCity" msprop:Generator_UserColumnName="IsNearCenterCity" msprop:Generator_ColumnPropNameInRow="IsNearCenterCity" msprop:Generator_ColumnVarNameInTable="columnIsNearCenterCity" msprop:Generator_ColumnPropNameInTable="IsNearCenterCityColumn" type="xs:boolean" />
              <xs:element name="IsNearCommunityCenter" msprop:Generator_UserColumnName="IsNearCommunityCenter" msprop:Generator_ColumnPropNameInRow="IsNearCommunityCenter" msprop:Generator_ColumnVarNameInTable="columnIsNearCommunityCenter" msprop:Generator_ColumnPropNameInTable="IsNearCommunityCenterColumn" type="xs:boolean" />
              <xs:element name="IsNearDining" msprop:Generator_UserColumnName="IsNearDining" msprop:Generator_ColumnPropNameInRow="IsNearDining" msprop:Generator_ColumnVarNameInTable="columnIsNearDining" msprop:Generator_ColumnPropNameInTable="IsNearDiningColumn" type="xs:boolean" />
              <xs:element name="IsNearFamilyActivities" msprop:Generator_UserColumnName="IsNearFamilyActivities" msprop:Generator_ColumnPropNameInRow="IsNearFamilyActivities" msprop:Generator_ColumnVarNameInTable="columnIsNearFamilyActivities" msprop:Generator_ColumnPropNameInTable="IsNearFamilyActivitiesColumn" type="xs:boolean" />
              <xs:element name="IsNearParks" msprop:Generator_UserColumnName="IsNearParks" msprop:Generator_ColumnPropNameInRow="IsNearParks" msprop:Generator_ColumnVarNameInTable="columnIsNearParks" msprop:Generator_ColumnPropNameInTable="IsNearParksColumn" type="xs:boolean" />
              <xs:element name="IsNearShopping" msprop:Generator_UserColumnName="IsNearShopping" msprop:Generator_ColumnPropNameInRow="IsNearShopping" msprop:Generator_ColumnVarNameInTable="columnIsNearShopping" msprop:Generator_ColumnPropNameInTable="IsNearShoppingColumn" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Viewings" msprop:Generator_UserTableName="Viewings" msprop:Generator_RowDeletedName="ViewingsRowDeleted" msprop:Generator_TableClassName="ViewingsDataTable" msprop:Generator_RowChangedName="ViewingsRowChanged" msprop:Generator_RowDeletingName="ViewingsRowDeleting" msprop:Generator_RowChangingName="ViewingsRowChanging" msprop:Generator_RowEvArgName="ViewingsRowChangeEvent" msprop:Generator_RowClassName="ViewingsRow" msprop:Generator_RowEvHandlerName="ViewingsRowChangeEventHandler" msprop:Generator_TablePropName="Viewings" msprop:Generator_TableVarName="tableViewings">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ViewingID" msprop:Generator_UserColumnName="ViewingID" msprop:Generator_ColumnPropNameInRow="ViewingID" msprop:Generator_ColumnVarNameInTable="columnViewingID" msprop:Generator_ColumnPropNameInTable="ViewingIDColumn" type="xs:int" />
              <xs:element name="MLS" msprop:Generator_UserColumnName="MLS" msprop:Generator_ColumnPropNameInRow="MLS" msprop:Generator_ColumnVarNameInTable="columnMLS" msprop:Generator_ColumnPropNameInTable="MLSColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BuyerName" msprop:Generator_UserColumnName="BuyerName" msprop:Generator_ColumnPropNameInRow="BuyerName" msprop:Generator_ColumnVarNameInTable="columnBuyerName" msprop:Generator_ColumnPropNameInTable="BuyerNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BuyerPhone" msprop:Generator_UserColumnName="BuyerPhone" msprop:Generator_ColumnPropNameInRow="BuyerPhone" msprop:Generator_ColumnVarNameInTable="columnBuyerPhone" msprop:Generator_ColumnPropNameInTable="BuyerPhoneColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ViewingDate" msprop:Generator_UserColumnName="ViewingDate" msprop:Generator_ColumnPropNameInRow="ViewingDate" msprop:Generator_ColumnVarNameInTable="columnViewingDate" msprop:Generator_ColumnPropNameInTable="ViewingDateColumn" type="xs:dateTime" />
              <xs:element name="WasInterested" msprop:Generator_UserColumnName="WasInterested" msprop:Generator_ColumnPropNameInRow="WasInterested" msprop:Generator_ColumnVarNameInTable="columnWasInterested" msprop:Generator_ColumnPropNameInTable="WasInterestedColumn" type="xs:boolean" />
              <xs:element name="Proceeding" msprop:Generator_UserColumnName="Proceeding" msprop:Generator_ColumnPropNameInRow="Proceeding" msprop:Generator_ColumnVarNameInTable="columnProceeding" msprop:Generator_ColumnPropNameInTable="ProceedingColumn" type="xs:boolean" />
              <xs:element name="BuyerIsMortgageApproved" msprop:Generator_UserColumnName="BuyerIsMortgageApproved" msprop:Generator_ColumnPropNameInRow="BuyerIsMortgageApproved" msprop:Generator_ColumnVarNameInTable="columnBuyerIsMortgageApproved" msprop:Generator_ColumnPropNameInTable="BuyerIsMortgageApprovedColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="BuyerMortgageLimit" msprop:Generator_UserColumnName="BuyerMortgageLimit" msprop:Generator_ColumnPropNameInRow="BuyerMortgageLimit" msprop:Generator_ColumnVarNameInTable="columnBuyerMortgageLimit" msprop:Generator_ColumnPropNameInTable="BuyerMortgageLimitColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Listings" />
      <xs:field xpath="mstns:MLS" />
    </xs:unique>
    <xs:unique name="Neighborhoods_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Neighborhoods" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="Viewings_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Viewings" />
      <xs:field xpath="mstns:ViewingID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Listings_Neighborhoods" msdata:parent="Neighborhoods" msdata:child="Listings" msdata:parentkey="ID" msdata:childkey="NeighborhoodID" msprop:Generator_UserRelationName="FK_Listings_Neighborhoods" msprop:Generator_RelationVarName="relationFK_Listings_Neighborhoods" msprop:Generator_UserChildTable="Listings" msprop:Generator_UserParentTable="Neighborhoods" msprop:Generator_ParentPropName="NeighborhoodsRow" msprop:Generator_ChildPropName="GetListingsRows" />
      <msdata:Relationship name="FK_Viewings_Listings" msdata:parent="Listings" msdata:child="Viewings" msdata:parentkey="MLS" msdata:childkey="MLS" msprop:Generator_UserRelationName="FK_Viewings_Listings" msprop:Generator_RelationVarName="relationFK_Viewings_Listings" msprop:Generator_UserChildTable="Viewings" msprop:Generator_UserParentTable="Listings" msprop:Generator_ParentPropName="ListingsRow" msprop:Generator_ChildPropName="GetViewingsRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>